MySQLi – Regexps You have seen MySQL pattern matching with LIKE …%. MySQL supports another type of pattern matching operation based on regular expressions and the REGEXP operator. If you are aware of PHP or PERL, then it”s very simple for you to understand because this matching is very similar to those scripting regular expressions. […]
Category Archives: mysqli
MySQLi – Data Types Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use; don”t define a field as 10 characters wide if you know you”re only going to use 2 characters. These types […]
MySQLi – Using Joins In the previous chapters, we were getting data from one table at a time. This is good enough for simple takes, but in most of the real world MySQL usages, you will often need to get data from multiple tables in a single query. You can use multiple tables in your […]