Welcome, Guest. Please login or register.

Author Topic: Devices case sensitive.  (Read 1559 times)

Araziel

  • Guest
Devices case sensitive.
« on: May 02, 2010, 09:59:38 PM »
Is there any way to get all the devices either upper case or lower case when they ae discovered in Nedi? This way multiple sql queries are not needed to pull data out of the DB.

Araziel

  • Guest
Re: Devices case sensitive.
« Reply #1 on: May 03, 2010, 03:58:17 PM »
Found it...    SELECT * FROM devices WHERE LCASE(name) regexp "ap"