Cara Menggunakan Query Search di Mysql
Berikut adalah cara menggunakan query search/pencarian data pada table data di mysql.
Dikutip dari https://www.w3schools.com/sql/sql_like.asp ( tanpa translate)
The SQL LIKE Operator
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
There are two wildcards often used in conjunction with the LIKE operator:
% – The percent sign represents zero, one, or multiple characters
_ – The underscore represents a single character
LIKE Operator | Description |
---|---|
WHERE CustomerName LIKE ‘a%’ | Finds any values that start with “a” |
WHERE CustomerName LIKE ‘%a’ | Finds any values that end with “a” |
WHERE CustomerName LIKE ‘%or%’ | Finds any values that have “or” in any position |
WHERE CustomerName LIKE ‘_r%’ | Finds any values that have “r” in the second position |
WHERE CustomerName LIKE ‘a__%’ | Finds any values that start with “a” and are at least 3 characters in length |
WHERE ContactName LIKE ‘a%o’ | Finds any values that start with “a” and ends with “o” |
Contoh untuk database wordpress dalam pendarian data pada table wp_post:
SELECT * FROM `wp_posts` WHERE post_title LIKE ‘%Mentri PUPR 2020%’
Untuk selanjutnya dapat di explore lebih jauh dalam menggunakan query search jika memang di butuhkan.