[Resolved] String comparison

[jek]

Hi!

I am having problems with the following code:

//$result = mysql_query( "SELECT `name`, `read` FROM `test` WHERE (`access` LIKE '\%,1,\%') " )

What I want to do is to use WHERE to only output the info where 'access' contains 1 (or ',1,'). The field access can contain any numbers from 1 to 10 divided by commas so I cant just check if it contains '1'...

Any ideas?

Thanks in advance / jek

[drawmack]

//$result = mysql_query( "SELECT `name`, `read` FROM `test` WHERE (`access` LIKE \"\%1\%\") " )

[jek]

Worked nicely, thanks.