trying to use LIKE but I might be wrong ...

[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

[mjlogan]

SELECT col1, col2, col3 FROM tbl WHERE test  = 48962 AND test != 34545

???

[fenway]

[quote author=mjlogan link=topic=123841.msg512440#msg512440 date=1169657721]
SELECT col1, col2, col3 FROM tbl WHERE test  = 48962 AND test != 34545
[/quote]
That's incorrect -- what you need is:
[code]
SELECT col1, col2, col3 FROM tbl WHERE test LIKE '%|48962|%'
[/code]

Of course, what you really need is a normalized DB, and not store delimited lists in a single fiedl