0

I am having records in a field (field_id) of a table (in mysql database), which is having ID stored per line, for example

1
2
3
10
11
13


above is one record, and I have many records similar to that.

and, when I am writing the query SELECT * FROM $table_name where field_id like '%1%'

then the rows having the results like
10
11
13

are also returned. I am upset. How to overcome this problem?

I found one fix to this, but it fails in most of the conditions, this is -

SELECT * FROM `$table_name` WHERE field_id like '%\n1%' OR '%1\n%'

This fails, when the (field_id) have only one record, for example, '1'. I want to catch everything, where line equals to 1, whether single line in the record, or many.

I am going mad for this.

Can someone provide me any way? Thanks.

3
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by mohansinhf
0

Hi mohansinhf,

If I understand correctly, you are trying to return all records that are equal to 1.

Try the following:

SELECT * FROM $table_name where field_id = '1'

Regards

Edited by trilithon: n/a

0

Check this out,it will work if i understood properly...

SELECT * FROM `$table_name` WHERE field_id like '%\n1%' OR field_id like '%1\n%' OR 
field_id like '1'

Hope it works :)

0

Thanks Akash Saikia and trilithon. You both gave me good solutions. Thanks again.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.