use PHP to select column in db

[phporcaffeine]

Example:

column 'test' = '|48962||34545|'

I need to be able to SELECT based on column 'test' but I may only have |48962| and not |34545|.

I tried:

SELECT col1, col2, col3 FROM tbl WHERE test LIKE |48962|

but it didn't work, any ideas?

-Thanks

[Jessica]

You need to surround strings with ''
"SELECT col1, col2, col3 FROM tbl WHERE test LIKE '|48962|'"

"didn't work" is very vague. Be more specific.

[phporcaffeine]

Okay I did surround in quotes ...

SELECT col1, col2, col3 FROM tbl WHERE test LIKE '|48962|'

I mean it returns an empty result set

[Jessica]

SELECT col1, col2, col3 FROM tbl WHERE test LIKE '%|48962|%'

[phporcaffeine]

thank you

[Jessica]

No problem.