Low cost ecommerce web development India flash website design

Select What You LIKE


The most basic form of search occurs against a single column, with the LIKE operator:
SELECT * FROM articles WHERE title LIKE 'How %'
The % is a wildcard character. The above statement will select all articles in which
the title begins with the word “How.” MySQL also has support for POSIX regular

How do I search my table?
expressions (the same as PHP’s ereg functions). Using the RLIKE operator, we
can compare a column using a regular expression:
SELECT * FROM articles WHERE title RLIKE '^How '
The above statement also selects every article in which the title begins with “How”
followed by a space.
With some work, these operators provide everything needed to explore your data.
Where the above approach becomes a burden is in performing a search against
multiple columns. For example,
SELECT * FROM articles
WHERE title LIKE '%how%' OR body LIKE '%how%'
For larger tables, this can require you to write some very complicated and unpleasant
queries.

website designer freelance ASP PHP ecommerce web developer
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110