LIKE statement in MySQL

[GlassFish]

Sponsored Links

Hello ,

i want to know about the searching criteria of records from database object in MySQL database.As a new for MySQL,I am going to write a query and I need to add the searching criteria according to the range and case of the record.

How can it would be possible.please help me regarding this.

Thank.

[Praetor]

The searching criteria is specified for every database in the database management system.If you didn't specify the matching criteria for records in the database.In case,you can't be facilitate from the database.

Different database uses the searching criteria and every one has some little bit changes in the syntax to define them.If we talk about the MySQL database.It uses the LIKE statement to fetch the records from the database tables.

[Katty]

If you need to show all the products from the table "Product_data" that contain the words JACK as the name of supplier.You can use the wildcard search pattern to display the name of that particular person in the table.

There are two wildcard characters are used and I think,the popular database also usage the same for pattern matching.The wild card characters are as follows-

1- % (percentage sign character).
2- _ (Underscore character).

[kelfro]

Use of % Wildcard :

One of the wild card named percentage sign wild card is used to disply

The most commonly used wildcard is the percent sign (%).This character is used with the search string, % specifies that match any number of occurrences of any character. For example,A table named Products and contains too many rows and I need to find all the name of products that start with the word MAN.
To find that required product,you can use the following SELECT statement:

SELECT pd_id, pd_name
FROM products
WHERE prod_name LIKE 'MAN%';

[Zecho]

Use of Underscore (_) wild card :

This is one of the useful wildcard named underscore (_). The underscore is used just like %, but act some different from %. the % matches multiple characters where as the underscore matches within a single character.

The example can given below can clarify,what happens behind this.execute the following statement in your MySQL terminal.

SELECT pd_id, pd_name
FROM products
WHERE prod_name LIKE '_MAN';

It will display only those record which can be started with any character but the second character must be MAN.

[Reegan]

Accessing cookies using LIKE statement

If you are using the MySQL as a back end for your web application then you access the cookies of the website that you have developed.

The following statement would allow to access the data from cookies of the website.

mysql> SELECT * FROM search WHERE Keywords LIKE '%cookies%';