 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
Regular expression Fundamentals. A regular expression (regex) is a powerful way of specifying a complex search. This article will take you through using them in MySQL. In MySQL .. {n} is "repeat-n-times" operator. . matches any single character. [...] macthes any character within the brackets. [abc] matches a, b or c. For a range use [a-z] to match any char and [0-9] any digit. * 0 or more quantifier, eg. y* would match any number of y characters. [0-9]* would match any no of digits. .* would match any number of anything. ^ assert start of subject and $ assert end of subject. To make regular experssions work in MySQL use them with REGEXP. mysql> select * from productinfo where pr_name regexp "^a"; +-------+--------------------+----------+------------+-------------+ | pr_id | pr_name | pr_batch | pr_exp | is_it_suppl | +-------+--------------------+----------+------------+-------------+ | 1 | Ampoxin 250 mg inj | A00122 | 2004-02-12 | n | | 2 | Ampoxin 500 mg inj | A0024 | 2004-08-12 | n | | 3 | Ampoxin 1gm inj | Adf122 | 2005-02-12 | n | +-------+--------------------+----------+------------+-------------+ 3 rows in set (0.00 sec) To force to a REGEXP comparision to case sensitive use BINARY keyword. mysql> select * from productinfo where pr_name regexp binary "^a"; Empty set (0.01 sec) To find batch no containing exacly six chars : mysql> select * from productinfo where pr_batch regexp "^......$"; +-------+--------------------+----------+------------+-------------+ | pr_id | pr_name | pr_batch | pr_exp | is_it_suppl | +-------+--------------------+----------+------------+-------------+ | 1 | Ampoxin 250 mg inj | A00122 | 2004-02-12 | n | | 3 | Ampoxin 1gm inj | Adf122 | 2005-02-12 | n | +-------+--------------------+----------+------------+-------------+ 2 rows in set (0.00 sec) Above query can be re-written as mysql> select * from productinfo where pr_batch regexp "^.{6}$"; +-------+--------------------+----------+------------+-------------+ | pr_id | pr_name | pr_batch | pr_exp | is_it_suppl | +-------+--------------------+----------+------------+-------------+ | 1 | Ampoxin 250 mg inj | A00122 | 2004-02-12 | n | | 3 | Ampoxin 1gm inj | Adf122 | 2005-02-12 | n | +-------+--------------------+----------+------------+-------------+ 2 rows in set (0.00 sec) | |||||
| Related Code Examples | |||||
