DrupalA-Zandnumberfilter

数字开头的字段值

SELECT * FROM MyTable WHERE MyColumn REGEXP '^[0-9]';

Drupal 7 SQL查询

A-Z的字母开头的字段值

db_select(‘MyTable’)->condition(‘MyColumn’,?$alpha.’%', ‘LIKE’);

数字开头的字段值

db_select(‘MyTable’)->condition(‘MyColumn’, ‘^[0-9]‘, ‘REGEXP’);

Drupal 6 SQL % 转义

在Drupal 6中直接使用SQL查询，但是注意%需要用%%来转义，意思就是在SQL中：

%% 代表 %
%s 代表 字符串的占位符

例如：

db_query("SELECT MyColumn FROM MyTable WHERE MyColumn='%s' AND title LIKE '%%%s%%'", $column, $tile);

(...)
Read the rest of Drupal A-Z and number filter (1 words)

© Li Xi for LixiPHP, 2014. | Permalink | No comment | Add to del.icio.us
Post tags: A-Z, Drupal 6, Drupal7, filter, MySQL, number, REGEXP

Feed enhanced by Better Feed from Ozh