Question about search/find

[SilkeH]

Hallo,

maybe somebody here can help me:
I need to search within the user fields, with a function that may be explained best as 'contains':
An example: within a field called "structure", I have one ore more numbers.
If I search for "269" I need to find not only those images that have the "269" entry in "structure", but also the ones that have "246, 269, 300" etc.

This does not work with = or 'like'

Has anybody an idea??

Thank you!

Silke

[Daan van Rooijen]

No guarantees, but have you tried this?

structure like '%269%'

[David Dyer-Bennet]

I think you need both, actually.  Something like:

    SELECT * FROM table WHERE Column LIKE "%test%";

(That's the underlying bit of SQL needed).  Not sure how to get from the search form to that, but I believe you can resort to writing raw SQL if you need to.)

[Daan van Rooijen]

> No guarantees, but have you tried this?
>
> structure like '%269%'

I've now tried it, and this should work:

structure like %269%

(so, without the apostrophes)

[SilkeH]

Thank you so much, Daan, this is working perfectly!
SilkeH