sqlite_query

Executes a SQL query and returns data returned by it.

A positive, numeric result identifier or 0 on success, or $null if there was an error.

To execute a prepared statement first prepare it with $sqlite_prepare.
To learn about prepared statements and binding values, see Prepared Statements.

In case of 0 is returned, it means that $sqlite_query was used to execute a query that doesn't return any data, such as INSERT or UPDATE.
A SELECT query always returns a result identifier on success, even if the query selected no rows. You can use $sqlite_num_rows to determine how many rows were returned.

If $null is returned you can determine the exact reason for the error by checking the value of %sqlite_errstr.
For more information about error handling, see Handling Errors

Note that if you want to bind a text value with more than one word, you must use the identifier form of syntax. If you don't care about the return value, you can use the built-in mIRC command /noop

Starting from mSQLite version 1.2.0 you can bind values even for non-prepared statements, but this only works when calling $sqlite_query as an identifier.

$sqlite_query can execute multiple queries seperated by semicolons. The returned result is the data returned by the last SQL query.
To see guidelines for writing SQL queries with mIRC SQLite, see Writing Queries.

Writing Queries
Handling Binary Data
Prepared Statements
sqlite_unbuffered_query
sqlite_exec
sqlite_fetch_row
sqlite_fetch_bound
sqlite_fetch_single
sqlite_num_rows
sqlite_free