Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
Drupal provides a standard, vendor-agnostic abstraction layer for accessing database servers.
2
votes
1
answer
500
views
How to write a WHERE clause with the '=' operator using db_select()?
I have MySQL query as:
SELECT *
FROM `field_revision_field_innostream_state`
WHERE `field_innostream_state_tid` =187
LIMIT 0 , 30
How to write a WHERE condition within db_select?
1
vote
1
answer
1k
views
SQL query to display a particular content type?
I only have access to the database and I need to figure out the list of content type through view; therefore, I am thinking to write SQL for it. Is it possible to do?
I am using Drupal 6. …
0
votes
2
answers
226
views
How to insert multiple tables into their respective backup tables using insert sql?
For the purpose of backup and restore i want few tables to be just backup while performing a restore process. I have created backup tables but now whenever i do restore process it shows:
PDOExceptio …
0
votes
How to insert multiple tables into their respective backup tables using insert sql?
I have resolved the issue by doing following thing, hope it may be useful to anyone too.
The cause of the problem is that the parent table and its corresponding backup table have same schema so whene …
0
votes
2
answers
827
views
How to change datatype of field in database table from varchar to int?
I have created custom table. Now I want to change datatype for a particular column in table. Column name is 'session_number' and its current type is varchar. I want to change it from varchar to int. I …