Skip to main content
Drupal Answers

Return to Question

deleted 43 characters in body; edited tags
Source Link
avpaderno ♦
avpaderno ♦
  • 97.9k
  • 15
  • 164
  • 284

It has become obvious to me that SQL syntax is a little different within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = '

SELECT name Nombre, mail Email FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25

';

$sql = 'SELECT name Nombre, mail Email  FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25';

Any suggestions, pleaseDo you have any suggestion? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a .module file.

Thanx$page_content in advancea module.

It has become obvious to me that SQL syntax is a little different within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = '

SELECT name Nombre, mail Email FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25

';

Any suggestions, please? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a .module file.

Thanx in advance.

It has become obvious to me that SQL syntax is a little different within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = 'SELECT name Nombre, mail Email  FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25';

Do you have any suggestion? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a module.

edited body
Source Link
MauF
MauF
  • 495
  • 1
  • 3
  • 12

It has become obvious to me that SQL syntax is a little differnetdifferent within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = '

SELECT name Nombre, mail Email FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25

';

Any suggestions, please? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a .module file.

Thanx in advance.

It has become obvious to me that SQL syntax is a little differnet within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = '

SELECT name Nombre, mail Email FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25

';

Any suggestions, please? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a .module file.

Thanx in advance.

It has become obvious to me that SQL syntax is a little different within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = '

SELECT name Nombre, mail Email FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25

';

Any suggestions, please? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a .module file.

Thanx in advance.

Source Link
MauF
MauF
  • 495
  • 1
  • 3
  • 12

Using wildcards in custom module outputting sql query

It has become obvious to me that SQL syntax is a little differnet within drupal.

After some fiddling around I am getting the hang of it, but I haven't been able to use wildcards succesfully.

$sql = '

SELECT name Nombre, mail Email FROM users WHERE status = 1 AND mail LIKE ('%@hotmail%') LIMIT 25

';

Any suggestions, please? I haven't been able to find (or I might be looking in the wrong places) for Drupal documentation regarding wildcards within $page_content in a .module file.

Thanx in advance.