mysql select query within a array

Question

Hi guys I have this situation

tabperfil
ta

bperfil.Cidade_Id -> values = 12,34,645,21

then I have a $id = 12

so I'm try to do this query

select * from tabperfil limit 0,5

but with a condiction for get the values of Cidade_Id and check with $id

if was a reverse situation I know

select * from tabperfil WHERE Cidade_Id IN ($id)

so how do something to works like this

select * from tabperfil WHERE ($id) in Cidade_Id

If you can't use proper grammar, why should we answer your question? — blake305
– blake305, Commented Jan 12, 2012 at 18:26
Have a look at mysql regular expression... you're going to be looking for scenarios where id matches the string up to the first comma, immediately follows a comma and ends with a comma, or where it follows a comma and ends the line. — Ben D
– Ben D, Commented Jan 12, 2012 at 18:27
nobody is perfect my friend, i m not a english expert but i try... if u can use, congrat's . i m learning — Alvaro Louzada
– Alvaro Louzada, Commented Jan 12, 2012 at 18:28
@blake305 There are a lot of non-native English speaking individuals here. Requiring proper grammar before answering a question would eliminate a lot of the help that could be provided. — jprofitt
– jprofitt, Commented Jan 12, 2012 at 18:28
@blake305 - Your edits consisted of a few capitalisations and a bit of missing code formatting. I would hardly say it was "unreadable". As the OP said in his comment, at least he's learning. These comments will likely get removed if we carry on like this, so let's leave it at that. — James Allardice
– James Allardice, Commented Jan 12, 2012 at 18:31

Wrikken · Accepted Answer · 2012-01-12 18:27:58Z

5

WHERE FIND_IN_SET($id, Cidade_Id) > 0

But you should really normalize your database. Having comma-seperated values in 1 column is asking for trouble.

answered Jan 12, 2012 at 18:27

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Henk Jansen Over a year ago

I really think that everyone who works with databases, or at least the programming of database applications, should know how to normalize a database, and not only know it, but also do it.

Alvaro Louzada Over a year ago

ok, i did this - maybe not right away but works citys => (1,3,5,7) $id = 1 $sql "SELECT * FROM TABLE WHERE (citys LIKE '$id,%' or citys LIKE '%,$id,%' OR citys LIKE '%,$id')"; thanks

Wrikken Over a year ago

Don't do that. Change your database layout so you don't have a column with comma-separated values anymore if possible.

Collectives™ on Stack Overflow

mysql select query within a array

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related