SQL Where Query

Chris_Evans

Hi there,
I've created a SET in the mysql database, and in my php code I have used the where syntax to select rows which contain a certain value. For example..

SET='Admin','Moderator','Member'

I then used phpmyadmin and highlighted both Admin and Moderator. Of course, the WHERE syntax no longer picks up the row as it has two values in it when searching for "Admin" in the where syntax.

Is there any other syntax that I can use that retrieves rows with the word admin in them?

Chris

AstroTeg

The MySQL docs will be your friend:
http://www.mysql.com/doc/en/SET.html
(even has query examples that appear to address your problem)

On a side note and a database design standpoint, I don't think this would be considered best practices. Since the idea of an "array" or "set" defeats the purpose of a relational database. At least with a set, its a predefined range of acceptable values. I dunno - your mileage will vary...

Chris_Evans

Well, I did think about using another database for that info, however the values in SET will never need to be changed so it'll be fine.

Anyway, thanks very much for your help! I did look in the docs but was looking for the WHERE clause, never thought of SET.

Thanks! Chris.