MySQL Forums
Forum List  »  German

Re: SELECT * FROM table WHERE blobfield IN (1,2,3,4,5,6,7,8)
Posted by: Mark Knochen
Date: March 10, 2014 07:47AM

Mh, so könnte es ansatzweise gehen ...


SELECT * FROM table WHERE CONCAT(",",CONVERT(blob_ids USING UTF8),",") REGEXP ',81,|,82,|,83,|,84,|,62,|,63,|,64,|,89,'

dafür müsste ich aber das hier noch serialisierte Feld blob_ids in ebenfalls kommagetrennte Werte unwandeln. geht das per MySQL?

Mark

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SELECT * FROM table WHERE blobfield IN (1,2,3,4,5,6,7,8)
1078
March 10, 2014 07:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.